package cn.edu.tyu.fiance.thingstype.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import cn.edu.tyu.fiance.thingstype.domain.Users;
import cn.edu.tyu.finance.util.DbUtil;

public class UserDaoImpl {
 public int addUser(Users users) throws SQLException{
	 //1. 获取数据库的链接
	 Connection conn= DbUtil.getConnection();
	 //2.编写sql语句
	 String sql="insert into users values(?,?,?)";
	 //3.获取预编译语句的执行者
	 PreparedStatement	ps= conn.prepareStatement(sql);
	 //4.设置参数
	ps.setString(1,users.getUserid());
	ps.setString(2,users.getUsername());
	ps.setString(3,users.getUserpsw());
	//5.执行SQL语句,返回影响的行数
	int res=ps.executeUpdate();
	//6释放数据库的链接
	DbUtil.backConn(conn, ps, null);
	return res;
 }
 public static void main(String[] args) throws SQLException {
	UserDaoImpl userDao=new UserDaoImpl();
	Users users =new Users();
	users.setUserid("1");
	users.setUsername("zs");
	users.setUserpsw("123456");
	int res =userDao.addUser(users);
	System.err.println("res="+res);
}
}